Purpose: Students should learn the special features of spreadsheets.

Exercise:1

Create a new spreadsheet and name it as ‘student mark sheet.ods’. Use formulae to calculate Total, Average and Result.

• Link to view the students marksheet model file. (Exercise).

Solution

---



• Link to copy the solution spreadsheet (Solution).

1. Teachers should ensure that the Students understand simple operations like Addition, Subtraction, Multiplication, and Division, before giving the Exercise.
2. Teachers should clarify the difference between text document tables and spreadsheets.
3. Students should identify the number of rows and columns before creating the spreadsheet.
4. Teachers should explain about the autofill feature (drag the autofill handle at the bottom right of a cell) and how this is useful in filling dates, days, or S.No).
5. Teachers should explain that the numbers indicate rows and alphabets indicate columns in Spreadsheet.
6. Teachers should ensure that all Students understand the freezing rows and columns feature, and also how to highlight the header row by using shadows for that row.
7. To know the formula of a specific cell, the formula bar at the top left of the sheet can be referred to.